/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 15/09/2025 14:17:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_repair_order
-- ----------------------------
DROP TABLE IF EXISTS `sc_repair_order`;
CREATE TABLE `sc_repair_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '工单 ID',
  `order_no` varchar(50) NOT NULL COMMENT '工单号',
  `user_id` bigint(20) NOT NULL COMMENT '申请人 ID',
  `community_id` bigint(20) NOT NULL COMMENT '社区 ID',
  `repair_type` tinyint(4) NOT NULL COMMENT '维修类型：1 - 水电，2 - 门窗，3 - 电梯，4 - 空调，5 - 其他',
  `title` varchar(200) NOT NULL COMMENT '维修标题',
  `description` text COMMENT '问题描述',
  `repair_address` varchar(255) DEFAULT NULL COMMENT '维修地址',
  `contact_phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `urgency_level` tinyint(4) DEFAULT '2' COMMENT '紧急程度：1 - 紧急，2 - 一般，3 - 不紧急',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态：1 - 待受理，2 - 已受理，3 - 维修中，4 - 已完成，5 - 已取消',
  `assign_to` bigint(20) DEFAULT NULL COMMENT '分配给 (维修人员 ID)',
  `assign_time` datetime DEFAULT NULL COMMENT '分配时间',
  `complete_time` datetime DEFAULT NULL COMMENT '完成时间',
  `satisfaction` tinyint(4) DEFAULT NULL COMMENT '满意度评分 (1-5 分)',
  `resident_id` bigint(20) DEFAULT NULL COMMENT '居民 ID',
  `location` varchar(2048) DEFAULT NULL COMMENT '维修地点（已废弃，请使用repair_images字段）',
  `priority` tinyint(4) DEFAULT '2' COMMENT '优先级',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `version` int(11) DEFAULT '1' COMMENT '版本号',
  `repair_images` json DEFAULT NULL COMMENT '维修图片信息，JSON格式存储多个文件信息，包含文件ID、文件名、URL、大小等信息',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'å¤‡æ³¨',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_no` (`order_no`),
  KEY `idx_order_no` (`order_no`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_status` (`status`),
  KEY `idx_repair_order_composite` (`community_id`,`status`,`create_time`),
  KEY `idx_repair_order_user_status` (`user_id`,`status`),
  KEY `idx_repair_order_update_by` (`update_by`),
  KEY `idx_repair_order_update_time` (`update_time`),
  KEY `idx_repair_order_priority` (`repair_type`,`status`,`create_time`),
  KEY `idx_repair_order_create_time` (`create_time`),
  KEY `idx_repair_order_community_status` (`community_id`,`status`),
  KEY `idx_repair_order_type` (`repair_type`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COMMENT='ç»´ä¿®å·¥å•è¡¨';

-- ----------------------------
-- Records of sc_repair_order
-- ----------------------------
BEGIN;
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (1, 'RO202501001', 1, 1, 1, '', 'æ°´ç®¡æ¼æ°´', NULL, '13800138001', 2, 5, NULL, NULL, NULL, NULL, 1, '1å·æ¥¼101å®¤', 2, NULL, '2025-06-26 02:36:06', 1, '2025-08-26 08:30:33', 0, 1, '[{\"id\": \"repair_image_1_1756197033\", \"status\": \"success\", \"fileUrl\": \"1å·æ¥¼101å®¤\", \"fileName\": \"repair_image_1.jpg\", \"filePath\": \"1å·æ¥¼101å®¤\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"createTime\": \"2025-08-26 08:30:33.000000\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"SYSTEM\", \"fileExtension\": \"jpg\", \"originalFileName\": \"repair_image_1.jpg\"}]', NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (2, 'RO202501002', 1, 2, 2, '', 'ç”µè·¯æ•…éšœ', NULL, '13800138002', 2, 4, 1, '2025-07-17 12:16:14', NULL, NULL, 2, '2å·æ¥¼202å®¤', 1, NULL, '2025-06-26 02:36:06', 1, '2025-08-26 08:30:33', 0, 1, '[{\"id\": \"repair_image_2_1756197033\", \"status\": \"success\", \"fileUrl\": \"2å·æ¥¼202å®¤\", \"fileName\": \"repair_image_2.jpg\", \"filePath\": \"2å·æ¥¼202å®¤\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"createTime\": \"2025-08-26 08:30:33.000000\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"SYSTEM\", \"fileExtension\": \"jpg\", \"originalFileName\": \"repair_image_2.jpg\"}]', NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (3, 'RO202501003', 1, 3, 3, '', 'ç”µæ¢¯æ•…éšœ', NULL, '13800138003', 2, 4, 6, '2025-07-17 11:01:40', NULL, NULL, 3, '3å·æ¥¼ç”µæ¢¯', 1, NULL, '2025-06-26 02:36:06', 9, '2025-08-26 08:30:33', 0, 1, '[{\"id\": \"repair_image_3_1756197033\", \"status\": \"success\", \"fileUrl\": \"3å·æ¥¼ç”µæ¢¯\", \"fileName\": \"repair_image_3.jpg\", \"filePath\": \"3å·æ¥¼ç”µæ¢¯\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"createTime\": \"2025-08-26 08:30:33.000000\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"SYSTEM\", \"fileExtension\": \"jpg\", \"originalFileName\": \"repair_image_3.jpg\"}]', NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (4, 'RO20250714150146334859', 9, 5, 4, '超山脚下配电箱维修', '超山脚下东边1号配电箱门被人卸下来了', '超山脚下东边1号配电箱', '13567114714', 2, 4, 1, '2025-07-16 19:39:12', NULL, NULL, NULL, NULL, 2, NULL, '2025-07-14 15:01:46', 9, '2025-07-17 05:25:16', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (5, 'RO20250717122104866840', 1, 4, 1, '空调维修', '空调一点也不冷，需要修理', '皮匠弄7-2-501', '13567114714', 2, 4, 1, '2025-07-17 12:21:21', NULL, NULL, NULL, NULL, 2, NULL, '2025-07-17 12:21:04', 1, '2025-07-17 04:29:38', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (6, 'RO20250717123041492791', 1, 4, 1, '空调又坏了', '反正就一直坏，是不是质量问题？', '皮匠弄7-2-501', '13567114714', 2, 4, 1, '2025-07-17 12:31:04', NULL, NULL, NULL, NULL, 2, NULL, '2025-07-17 12:30:42', 1, '2025-07-17 05:14:56', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (7, 'RO20250717131734531849', 9, 5, 1, '下水道堵了', '下水道堵了下水道堵了下水道堵了下水道堵了', '二小区14-1-401', '13567114741', 2, 4, 6, '2025-07-17 13:17:47', NULL, NULL, NULL, NULL, 2, NULL, '2025-07-17 13:17:35', 9, '2025-07-17 05:18:23', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (8, 'RO20250717133859258057', 9, 3, 3, '电梯坏了', '一小区48-2-601，电梯坏了', '一小区48-2-601', '18329188884', 2, 4, 7, '2025-07-17 13:39:23', '2025-07-17 13:43:22', 1, NULL, NULL, 2, NULL, '2025-07-17 13:38:59', 9, '2025-07-17 05:43:22', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (9, 'RO20250717135629403071', 9, 3, 3, '电梯坏了', '电梯坏了电梯坏了电梯坏了电梯坏了', '12-1-501', '13567114714', 2, 4, 9, '2025-07-17 13:56:41', '2025-07-17 14:01:20', 3, NULL, NULL, 2, NULL, '2025-07-17 13:56:30', 9, '2025-07-17 06:01:19', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (10, 'RO20250728114013143934', 9, 5, 1, '水电维修水电维修', '水电维修水电维修水电维修水电维修', '水电维修水电维修水电维修水电维修水电维修水电维修', '13569874545', 1, 3, 30, '2025-07-28 11:40:48', NULL, NULL, NULL, NULL, 2, NULL, '2025-07-28 11:40:14', 9, '2025-07-28 03:45:35', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (11, 'RO20250808150906755493', 9, 5, 2, '浙江省杭州市临平区塘栖镇超山小区001栋1单元102号', '浙江省杭州市临平区塘栖镇超山小区001栋1单元102号', '浙江省杭州市临平区塘栖镇超山小区001栋1单元102号', '13567458548', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-08 15:09:06', NULL, '2025-08-08 15:09:06', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (12, 'RO20250811171820713731', 9, 5, 1, '浙江省杭州市临平区塘栖镇超山小区001栋1单元102号', '浙江省杭州市临平区塘栖镇超山小区001栋1单元102号', '浙江省杭州市临平区塘栖镇超山小区001栋1单元102号', '18329188728', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-11 17:18:21', NULL, '2025-08-11 17:18:21', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (13, 'RO20250811180332592308', 9, 5, 2, '门窗门窗门窗门窗', '门窗门窗门窗门窗门窗门窗门窗门窗', '浙江省杭州市临平区塘栖镇超山小区001栋1单元102号', '13567114714', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-11 18:03:32', NULL, '2025-08-11 18:03:32', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (14, 'RO20250812135933299141', 32, 12, 4, '空调坏了空调坏了', '空调坏了空调坏了空调坏了空调坏了', '浙江省杭州市临平区临平街道小橘子社区一1栋1单元101号', '18329188129', 1, 2, 32, '2025-08-12 14:00:30', NULL, NULL, NULL, NULL, 2, NULL, '2025-08-12 13:59:33', 32, '2025-08-12 06:00:30', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (15, 'RO20250829144940759033', 45, 23, 1, '没电了', '没电了没电了没电了没电了没电了没电了没电了', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', '19558156909', 3, 3, 42, '2025-08-29 16:43:33', NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 14:49:40', 42, '2025-08-29 09:05:19', 0, 4, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (16, 'RO20250829152509523035', 45, 23, 2, '门窗坏了', '我们家窗户被熊孩子砸烂了，快来人！', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 3, 5, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 15:25:09', 45, '2025-08-29 09:27:52', 0, 2, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (17, 'RO20250829153018616751', 45, 23, 3, '电梯坏了', '电梯坏了电梯坏了电梯坏了电梯坏了电梯坏了电梯坏了', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 15:30:19', 45, '2025-08-29 15:30:19', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (18, 'RO20250829155257538918', 45, 23, 4, '空调坏了', '空调坏了空调坏了空调坏了空调坏了', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 3, 3, 42, '2025-08-29 16:35:14', NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 15:52:58', 42, '2025-08-29 08:43:15', 0, 4, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (19, 'RO20250829155409960456', 45, 23, 5, '墙壁被砸了一个洞', '墙壁被砸了一个洞', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 3, 42, '2025-08-29 16:29:46', NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 15:54:09', 42, '2025-08-29 08:30:10', 0, 4, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (20, 'RO20250829155733802220', 45, 23, 5, '错误错误', '错误错误错误错误错误错误错误错误错误错误', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 3, 4, 42, '2025-08-29 16:21:14', '2025-08-29 16:46:02', 5, NULL, NULL, 2, 45, '2025-08-29 15:57:34', 42, '2025-08-29 08:46:02', 0, 5, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (21, 'RO20250829174237134884', 45, 23, 1, '水管堵住了', '水管堵住了水管堵住了水管堵住了水管堵住了水管堵住了', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 5, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 17:42:38', 45, '2025-08-29 09:57:49', 0, 2, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (22, 'RO20250829174325917136', 45, 23, 5, '测试报修', '这是一个测试报修，包含图片上传功能测试', '测试地址', '13800138000', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 17:43:26', 45, '2025-08-29 17:43:26', 0, 1, '[{\"id\": \"repair_image_22_1756460605681_0\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/house_type_plan/20250814181303_ce9ea78435174284b0915a59001a2a91.jpg\", \"document\": false, \"fileName\": \"20250814181303_ce9ea78435174284b0915a59001a2a91.jpg\", \"filePath\": \"http://localhost:9000/smart-community/house_type_plan/20250814181303_ce9ea78435174284b0915a59001a2a91.jpg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-08-29 17:43:25\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpg\", \"originalFileName\": \"20250814181303_ce9ea78435174284b0915a59001a2a91.jpg\", \"fileSizeFormatted\": \"0 B\"}]', NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (23, 'RO20250829175511671873', 45, 23, 1, '水龙头爆炸了', '水龙头爆炸了水龙头爆炸了水龙头爆炸了水龙头爆炸了水龙头爆炸了', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 5, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-29 17:55:11', 45, '2025-08-29 09:58:15', 0, 2, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (24, 'RO20250829181058309483', 42, 23, 1, 'Web端测试01', '1111111111111111111111', '测试地址', '13567114714', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 42, '2025-08-29 18:10:58', 42, '2025-08-29 18:10:58', 0, 1, '[{\"id\": \"repair_image_24_1756462258334_0\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/image/20250829180959_706ff54d6c124f97ac0ef05bdbe00d14.jpg\", \"document\": false, \"fileName\": \"20250829180959_706ff54d6c124f97ac0ef05bdbe00d14.jpg\", \"filePath\": \"http://localhost:9000/smart-community/image/20250829180959_706ff54d6c124f97ac0ef05bdbe00d14.jpg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-08-29 18:10:58\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpg\", \"originalFileName\": \"20250829180959_706ff54d6c124f97ac0ef05bdbe00d14.jpg\", \"fileSizeFormatted\": \"0 B\"}, {\"id\": \"repair_image_24_1756462258334_1\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/image/20250829181056_769c879ca66e440ab600c4b759f14658.jpeg\", \"document\": false, \"fileName\": \"20250829181056_769c879ca66e440ab600c4b759f14658.jpeg\", \"filePath\": \"http://localhost:9000/smart-community/image/20250829181056_769c879ca66e440ab600c4b759f14658.jpeg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-08-29 18:10:58\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpeg\", \"originalFileName\": \"20250829181056_769c879ca66e440ab600c4b759f14658.jpeg\", \"fileSizeFormatted\": \"0 B\"}]', '2222');
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (25, 'RO20250830003916051306', 45, 23, 2, '测试上传图片 01', '测试上传图片 01测试上传图片 01测试上传图片 01测试上传图片 01测试上传图片 01', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-30 00:39:17', 45, '2025-08-30 00:39:17', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (26, 'RO20250830004038812338', 45, 23, 5, '测试上传图片 01测试上传图片 01', '测试上传图片 01测试上传图片 01测试上传图片 01测试上传图片 01测试上传图片 01测试上传图片 01', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-30 00:40:38', 45, '2025-08-30 00:40:38', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (27, 'RO20250830014435748372', 42, 23, 1, ' 请先阅读“DataScopeFeign使用示例.md”', ' 请先阅读“DataScopeFeign使用示例.md” 请先阅读“DataScopeFeign使用示例.md” 请先阅读“DataScopeFeign使用示例.md”', ' 请先阅读“DataScopeFeign使用示例.md”', '13567114714', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 42, '2025-08-30 01:44:36', 42, '2025-08-30 01:44:36', 0, 1, '[{\"id\": \"repair_image_27_1756489476012_0\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/image/20250830014423_fe0560ec87aa4015ac0b0a0ad3088924.jpg\", \"document\": false, \"fileName\": \"20250830014423_fe0560ec87aa4015ac0b0a0ad3088924.jpg\", \"filePath\": \"http://localhost:9000/smart-community/image/20250830014423_fe0560ec87aa4015ac0b0a0ad3088924.jpg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-08-30 01:44:36\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpg\", \"originalFileName\": \"20250830014423_fe0560ec87aa4015ac0b0a0ad3088924.jpg\", \"fileSizeFormatted\": \"0 B\"}, {\"id\": \"repair_image_27_1756489476012_1\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/image/20250830000659_bedd96f6e65148749c587ff9e189cc51.png\", \"document\": false, \"fileName\": \"20250830000659_bedd96f6e65148749c587ff9e189cc51.png\", \"filePath\": \"http://localhost:9000/smart-community/image/20250830000659_bedd96f6e65148749c587ff9e189cc51.png\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-08-30 01:44:36\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"png\", \"originalFileName\": \"20250830000659_bedd96f6e65148749c587ff9e189cc51.png\", \"fileSizeFormatted\": \"0 B\"}]', ' 请先阅读“DataScopeFeign使用示例.md”');
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (28, 'RO20250830015159028144', 45, 23, 1, '1111111111111111111111111111111111', '1111111111111111111111111111111111', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 3, 42, '2025-08-30 23:04:03', NULL, NULL, NULL, NULL, 2, 45, '2025-08-30 01:52:00', 42, '2025-09-04 10:25:54', 0, 4, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (29, 'RO20250830020155484868', 45, 23, 2, '请先阅读“DataScopeFeign使用示例.md”、“Feign接口开发规范.md”、“App端编码规范权威标准声明.md”、', '请先阅读“DataScopeFeign使用示例.md”、“Feign接口开发规范.md”、“App端编码规范权威标准声明.md”、“Java后端SpringBoot代码开发规范.md”、“系统状态枚举权威标准声明.md”、“Element Plus组件编码规范权威标准声明.md”、“智慧社区微服务架构总览.md”、“用户上传文件功能使用指南.md”这些权威文档。\nApp端提交报修时，“imageList”字段还是空数组，说明app端每次调用用户文件上传接口之后，并没有正确地保存用户文件上传接口返回的文件信息。\n请再修正！\n如果任务过长，或文件过长，可以分批执行。\n任务执行完毕后，请把调整更新到所有相关的设计文档中去。', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2025-08-30 02:01:55', 45, '2025-08-30 02:01:55', 0, 1, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (30, 'RO20250830020728134490', 45, 23, 2, 'imageListimageListimageList', 'imageListimageListimageListimageListimageListimageListimageListimageListimageListimageList', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 2, 42, '2025-09-10 16:12:21', NULL, NULL, NULL, NULL, 2, 45, '2025-08-30 02:07:29', 42, '2025-09-10 08:12:21', 0, 3, NULL, NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (31, 'RO20250830021403745930', 45, 23, 2, 'Token有效，恢复登录状态', 'Token有效，恢复登录状态Token有效，恢复登录状态Token有效，恢复登录状态', '浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', NULL, 2, 2, 42, '2025-08-30 23:03:20', NULL, NULL, NULL, NULL, 2, 45, '2025-08-30 02:14:03', 42, '2025-08-30 15:03:20', 0, 3, '[{\"id\": \"repair_image_31_1756491243254_0\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/repair_image/20250830021354_7718f86dcbf5433e819196cb2ec90e21.jpg\", \"document\": false, \"fileName\": \"20250830021354_7718f86dcbf5433e819196cb2ec90e21.jpg\", \"filePath\": \"http://localhost:9000/smart-community/repair_image/20250830021354_7718f86dcbf5433e819196cb2ec90e21.jpg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-08-30 02:14:03\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpg\", \"originalFileName\": \"20250830021354_7718f86dcbf5433e819196cb2ec90e21.jpg\", \"fileSizeFormatted\": \"0 B\"}, {\"id\": \"repair_image_31_1756491243254_1\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/repair_image/20250830020151_df7eb6de6441411eaf870b490a4653ab.jpg\", \"document\": false, \"fileName\": \"20250830020151_df7eb6de6441411eaf870b490a4653ab.jpg\", \"filePath\": \"http://localhost:9000/smart-community/repair_image/20250830020151_df7eb6de6441411eaf870b490a4653ab.jpg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-08-30 02:14:03\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpg\", \"originalFileName\": \"20250830020151_df7eb6de6441411eaf870b490a4653ab.jpg\", \"fileSizeFormatted\": \"0 B\"}]', NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (32, 'RO20250902201516665736', 31, 5, 1, '你爹家水管堵住了', '你爹家水管堵住了你爹家水管堵住了你爹家水管堵住了你爹家水管堵住了', '浙江省杭州市临平区塘栖镇超山小区001栋1单元101号', NULL, 3, 5, NULL, NULL, NULL, NULL, NULL, NULL, 2, 31, '2025-09-02 20:15:16', 31, '2025-09-02 12:16:06', 0, 2, '[{\"id\": \"repair_image_32_1756815316706_0\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/other/20250901155056_a2af7ba5b4034124a1c5f95f12a50010.png\", \"document\": false, \"fileName\": \"20250901155056_a2af7ba5b4034124a1c5f95f12a50010.png\", \"filePath\": \"http://localhost:9000/smart-community/other/20250901155056_a2af7ba5b4034124a1c5f95f12a50010.png\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-09-02T20:15:16.706\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"png\", \"originalFileName\": \"20250901155056_a2af7ba5b4034124a1c5f95f12a50010.png\", \"fileSizeFormatted\": \"0 B\", \"createTimeFormatted\": \"2025-09-02 20:15:16\", \"createTimeAsLocalDateTime\": \"2025-09-02 20:15:16\"}, {\"id\": \"repair_image_32_1756815316706_1\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/company_logo/20250901170949_8b2fb7a19284402aa8eaecc9fddb4f2a.jpeg\", \"document\": false, \"fileName\": \"20250901170949_8b2fb7a19284402aa8eaecc9fddb4f2a.jpeg\", \"filePath\": \"http://localhost:9000/smart-community/company_logo/20250901170949_8b2fb7a19284402aa8eaecc9fddb4f2a.jpeg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-09-02T20:15:16.706\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpeg\", \"originalFileName\": \"20250901170949_8b2fb7a19284402aa8eaecc9fddb4f2a.jpeg\", \"fileSizeFormatted\": \"0 B\", \"createTimeFormatted\": \"2025-09-02 20:15:16\", \"createTimeAsLocalDateTime\": \"2025-09-02 20:15:16\"}]', NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (33, 'RO20250904155430492403', 31, 5, 1, '水表停了，需要修理', '水表停了，需要修理水表停了，需要修理水表停了，需要修理水表停了，需要修理', '浙江省杭州市临平区塘栖镇超山小区001栋1单元101号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 31, '2025-09-04 15:54:31', 31, '2025-09-04 15:54:31', 0, 1, '[{\"id\": \"repair_image_33_1756972471454_0\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/payment_qr/20250904104801_ecd23b2a83e240eabe67e08cdcab3de7.jpg\", \"document\": false, \"fileName\": \"20250904104801_ecd23b2a83e240eabe67e08cdcab3de7.jpg\", \"filePath\": \"http://localhost:9000/smart-community/payment_qr/20250904104801_ecd23b2a83e240eabe67e08cdcab3de7.jpg\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-09-04T15:54:31.455\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"jpg\", \"originalFileName\": \"20250904104801_ecd23b2a83e240eabe67e08cdcab3de7.jpg\", \"fileSizeFormatted\": \"0 B\", \"createTimeFormatted\": \"2025-09-04 15:54:31\", \"createTimeAsLocalDateTime\": \"2025-09-04 15:54:31\"}, {\"id\": \"repair_image_33_1756972471455_1\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/repair_image/20250904155428_51a40597a2264301ae66b7cae80d272e.png\", \"document\": false, \"fileName\": \"20250904155428_51a40597a2264301ae66b7cae80d272e.png\", \"filePath\": \"http://localhost:9000/smart-community/repair_image/20250904155428_51a40597a2264301ae66b7cae80d272e.png\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-09-04T15:54:31.455\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"png\", \"originalFileName\": \"20250904155428_51a40597a2264301ae66b7cae80d272e.png\", \"fileSizeFormatted\": \"0 B\", \"createTimeFormatted\": \"2025-09-04 15:54:31\", \"createTimeAsLocalDateTime\": \"2025-09-04 15:54:31\"}]', NULL);
INSERT INTO `sc_repair_order` (`id`, `order_no`, `user_id`, `community_id`, `repair_type`, `title`, `description`, `repair_address`, `contact_phone`, `urgency_level`, `status`, `assign_to`, `assign_time`, `complete_time`, `satisfaction`, `resident_id`, `location`, `priority`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `repair_images`, `remark`) VALUES (34, 'RO20250911104641134892', 31, 5, 2, '请帮我看看窗户', '窗户怀了，关不上了，请快来。', '浙江省杭州市临平区塘栖镇超山小区001栋1单元101号', '13567474147', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 31, '2025-09-11 10:46:41', 31, '2025-09-11 10:46:41', 0, 1, '[{\"id\": \"repair_image_34_1757558801460_0\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/repair_image/20250911104538_5b48a15f97304ed49c09f75edb7a4559.png\", \"document\": false, \"fileName\": \"20250911104538_5b48a15f97304ed49c09f75edb7a4559.png\", \"filePath\": \"http://localhost:9000/smart-community/repair_image/20250911104538_5b48a15f97304ed49c09f75edb7a4559.png\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-09-11T10:46:41.460\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"png\", \"originalFileName\": \"20250911104538_5b48a15f97304ed49c09f75edb7a4559.png\", \"fileSizeFormatted\": \"0 B\", \"createTimeFormatted\": \"2025-09-11 10:46:41\", \"createTimeAsLocalDateTime\": \"2025-09-11 10:46:41\"}, {\"id\": \"repair_image_34_1757558801460_1\", \"audio\": false, \"image\": true, \"video\": false, \"status\": \"success\", \"fileUrl\": \"http://localhost:9000/smart-community/repair_image/20250911104547_e7ccbdc3dc0644abac49779f34be14ce.png\", \"document\": false, \"fileName\": \"20250911104547_e7ccbdc3dc0644abac49779f34be14ce.png\", \"filePath\": \"http://localhost:9000/smart-community/repair_image/20250911104547_e7ccbdc3dc0644abac49779f34be14ce.png\", \"fileSize\": 0, \"fileType\": \"image/jpeg\", \"isPublic\": true, \"sortOrder\": 0, \"viewCount\": 0, \"createTime\": \"2025-09-11T10:46:41.460\", \"uploadType\": \"REPAIR_IMAGE\", \"uploadSource\": \"APP\", \"downloadCount\": 0, \"fileExtension\": \"png\", \"originalFileName\": \"20250911104547_e7ccbdc3dc0644abac49779f34be14ce.png\", \"fileSizeFormatted\": \"0 B\", \"createTimeFormatted\": \"2025-09-11 10:46:41\", \"createTimeAsLocalDateTime\": \"2025-09-11 10:46:41\"}]', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
